package world.liquor.dao;

import java.sql.SQLException;
import java.util.ArrayList;

import world.liquor.domain.BeerInfo;

public interface BeerDAO {
	public void insertBeer(BeerInfo beerInfo) throws SQLException;
	public int updateBeer(BeerInfo beerInfo) throws SQLException;
	public int deleteBeerById(String beer_info_id) throws SQLException;
	public BeerInfo selectBeerById(String beer_info_id) throws SQLException;
	public BeerInfo selectBeerByBeerName(String beer_info_name) throws SQLException;
	public ArrayList<BeerInfo> selectBeerByManufacturer(String manufacturer) throws SQLException;
	public ArrayList<BeerInfo> selectBeerByCountry(String country) throws SQLException;
	public ArrayList<BeerInfo> selectBeerByMultipleCategory(String search_param) throws SQLException;
	public ArrayList<BeerInfo> selectAllBeer() throws SQLException;
}
